| FundSourceLendingInstitution |
| EntityType | Dependent |
| Logical Entity Name | FundSourceLendingInstitution |
| Default Table Name | FaFundSourceBanks |
| Logical Only | NO |
| Definition | |
| Note |
| FundSourceLendingInstitution Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| Id | INTEGER | NO | ||
FundSourceId |
INTEGER | NO | ||
CampusId |
INTEGER | NO | ||
LenderLendingInstitutionId |
INTEGER | YES | ||
ServicerLendingInstitutionId |
INTEGER | YES | ||
GuarantorLendingInstitutionId |
INTEGER | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO |
| FundSourceLendingInstitution Keys |
| Key Name | Key Type | Keys |
| FaFundSourceBanks_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId |
| FaFundSourceBanks_ServicerFaLenderID_N_N_IDX | Inversion Entry | ServicerLendingInstitutionId |
| FaFundSourceBanks_LenderFaLenderID_N_N_IDX | Inversion Entry | LenderLendingInstitutionId |
| FaFundSourceBanks_GuarantorFaLenderID_N_N_IDX | Inversion Entry | GuarantorLendingInstitutionId |
| FaFundSourceBanks_FaFundSourceBanksID_U_N_IDX | Unique Constraint | Id |
| FaFundSourceBanks_FaFundSourceID_SyCampusID_U_C_IDX | PrimaryKey | FundSourceId, CampusId |
| FundSourceLendingInstitution Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| FundSource | Identifying | One To Zero or More | FundSourceId | NO | |||
| LendingInstitution | Non-Identifying | Zero or One to Zero or More | GuarantorLendingInstitutionId | NO | |||
| LendingInstitution | Non-Identifying | Zero or One to Zero or More | LenderLendingInstitutionId | NO | |||
| LendingInstitution | Non-Identifying | Zero or One to Zero or More | ServicerLendingInstitutionId | NO | |||
| Campus | Identifying | One To Zero or More | CampusId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FundSourceLendingInstitution Check Constraints |
| Check Constraint Name | CheckConstraint |